Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTDBS503 Mapping and Delivery Guide
Create a data warehouse
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | ICTDBS503 - Create a data warehouse |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to design, develop and implement a data warehouse within an organisation.It applies to individuals who are senior database staff required to provide data warehouse functionality for their organisation.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to: equipment and materials industry software packages the business requirements computers configurable as information servers the enterprise’s knowledge management strategy internet connectivity tools the local area network (LAN), with a relational database management system (DBMS) proxy server software specialised internet security software. Assessors must satisfy NVR/AQTF assessor requirements. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Identify the required data and sources |
| |||||||
Element: Determine warehouse operational steps and processes |
| |||||||
Element: Design and develop warehouse features |
| |||||||
Element: Test and implement the data warehouse |
| |||||||
Element: Finalise work processes |
|